Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  


RE: Extracting data from XML file
~Umberto Nongeroson 26.Nov.03 03:25 PM a Web browser
Applications Development 6.0.2 CF1 Windows 2000


Here is a demo. I put your data in a string, not a file. You asked the same question in the Notes/Domino 4 and 5 forum. The method here is only for Notes/Domino 6.


    Sub Click(Source As Button)
    Const
    xml = {<NameList>
    <Person>
    <FirstName>John</FirstName>
    <SurName>Wiliams</SurName>
    <Address>
    <Street>123 My Street</Street>
    <Zip>0500</Zip>
    </Address>
    </Person>
    <Person>
    <FirstName>Paul</FirstName>
    <SurName>Smith</SurName>
    <Address>
    <Street>222 Alabama Street</Street>
    <Zip>0522</Zip>
    </Address>
    </Person>
    </NameList>}

    Dim session As New NotesSession

    Dim xmlstream As NotesStream
    Set xmlstream = session.CreateStream
    xmlstream.WriteText xml

    Dim parser As NotesDOMParser
    Set parser = session.CreateDOMParser(xmlstream)
    parser.Process

    Dim people As NotesDOMNodeList
    Set people = parser.Document.GetElementsByTagName("Person")

    For
    i& = 1 To people.NumberOfEntries
    Dim person As NotesDOMElementNode
    Set person = people.GetItem(i&)

    Dim
    address As NotesDOMElementNode
    Set address = person.GetElementsByTagName("Address").GetItem(1)

    Dim
    street As NotesDOMElementNode
    Set street = address.GetElementsByTagName("Street").GetItem(1)

    Dim
    zip As NotesDOMElementNode
    Set zip = address.GetElementsByTagName("Zip").GetItem(1)

    Messagebox
    "Person #" & Cstr(i&) _
    &
    Chr$(10) & "Street: " & street.FirstChild.NodeValue _
    &
    Chr$(10) & "Zip: " & zip.FirstChild.NodeValue
    Next

    End Sub




Extracting data from XML file (~Phil Fezkroman... 26.Nov.03)
. . RE: Extracting data from XML file (~Kirk Elreterod... 26.Nov.03)
. . . . Thank you for your help, much appre... (~Phil Fezkroman... 27.Nov.03)


Document Options






  Document options
Print this pagePrint this page

Search this forum

Forum views and search


  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS